CREATE procedure [dbo].[BAEEventSearch] @showAll int,
     @start varchar(15),
     @end varchar(15),
     @state varchar(15),
     @title varchar(60),
     @city varchar(255) as
if(@showAll = 1 AND @start <> '' AND @end <> '' AND @state <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start AND BEGIN_DATE <= @end))
            AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND CITY LIKE '%' + @city + '%' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* 5C4 */
    /* Start, end, state AND title are provided */
    else if(@showAll = 1 AND @start <> '' AND @end <> '' AND @state <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start AND BEGIN_DATE <= @end))
            AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, end, title AND city are provided */
    else if(@showAll=1 AND @start <> '' AND @end <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start AND BEGIN_DATE <= @end))
            AND UPPER(TITLE) like '%' + @title + '%' AND CITY LIKE '%' + @city + '%' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, end, state AND city are provided */
    else if(@showAll = 1 AND @start <> '' AND @end <> '' AND @state <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start AND BEGIN_DATE <= @end))
            AND @state = STATE_PROVINCE AND CITY like '%' + @city + '%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, state, title AND city are provided */
    else if(@showAll=1 AND @start <> '' AND @state <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start))
            AND @state = STATE_PROVINCE AND UPPER(TITLE) like '%' + @title + '%' AND CITY like '%' + @city + '%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End, state, title AND city are provided */
    else if(@showAll=1 AND @end <> '' AND @state <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE <= @end))
            AND @state = STATE_PROVINCE AND UPPER(TITLE) like '%' + @title + '%' AND CITY like '%' + @city + '%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* 5C3 */
    /* Start, end AND state are provided */
    else if(@showAll = 1 AND @start <> '' AND @end <> '' AND @state <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE <= @end AND BEGIN_DATE >= @start ))
            AND @state = STATE_PROVINCE  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* Start, end AND title are provided */
    else if(@showAll = 1 AND @start <> '' AND @end <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE <= @end AND BEGIN_DATE >= @start ))
             AND UPPER(TITLE) LIKE '%'+@title+'%' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* Start, end AND city are provided */
    else if(@showAll = 1 AND @start <> '' AND @end <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start AND BEGIN_DATE <= @end))
            AND CITY LIKE '%' + @city + '%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, state AND title are provided */
    else if(@showAll = 1 AND @start <> '' AND @state <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start)
            AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, state AND city are provided */
    else if(@showAll = 1 AND @start <> '' AND @state <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start)
            AND @state = STATE_PROVINCE AND CITY like '%' + @city + '%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, title AND city are provided */
    else if(@showAll = 1 AND @start <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start)
            AND UPPER(TITLE) LIKE '%' + @title + '%' AND CITY LIKE '%' + @city + '%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End, state AND title are provided */
    else if(@showAll = 1 AND @end <> '' AND @state <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE <= @end)
            AND @state = STATE_PROVINCE AND UPPER(TITLE) like '%' + @title + '%' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End, state AND city are provided */
    else if(@showAll = 1 AND @end <> '' AND @state <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE <= @end))
            AND @state = STATE_PROVINCE AND CITY like '%' + @city + '%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End, title AND city are provided */
    else if(@showAll = 1 AND @end <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE <= @end))
            AND UPPER(TITLE) like '%'+@title+'%' AND CITY like '%'+@city+'%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* State, title AND city are provided */
    else if(@showAll = 1 AND @state <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND CITY LIKE '%' + @city + '%'
        AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* 5C2 */

    /* Start AND end are provided */
    else if( @showAll = 1 AND @start <> '' AND @end <> '' )
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start AND BEGIN_DATE <= @end))
             AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start AND state are provided */
    else if(@showAll = 1 AND @start <> '' AND @state <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start)
            AND @state = STATE_PROVINCE AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start AND title are provided */
    else if(@showAll = 1 AND @start <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start  )
            AND UPPER(TITLE) LIKE '%'+@title+'%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start AND City are provided */
    else if(@showAll = 1 AND @start <> '' AND @city <> '')

        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start  )
            AND CITY LIKE '%' + @city + '%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End AND state are provided */
    else if(@showAll = 1 AND @end <> '' AND @state <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE <= @end)
            AND @state = STATE_PROVINCE AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End AND title are provided */
    else if(@showAll = 1 AND @end <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE <= @end)
            AND UPPER(TITLE) LIKE '%'+@title+'%' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End AND city are provided */
    else if(@showAll = 1 AND @end <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE <= @end)
            AND CITY LIKE '%' + @city + '%' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* State AND title are provided */
    else if(@showAll = 1 AND @state <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* State AND city are provided */
    else if(@showAll = 1 AND @state <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND @state=STATE_PROVINCE AND CITY like '%'+@city+'%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;    

    /*Title AND city are provided */
    else if(@showAll = 1 AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND UPPER(TITLE) LIKE  '%' + @title + '%' AND CITY LIKE '%' + @city + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start only */
    else if(@showAll = 1 AND @start <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start) AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End only */
    else if(@showAll = 1 AND @end <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE <= @end) AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* State only */
    else if(@showAll = 1 AND @state <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND @state = STATE_PROVINCE  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* Title only */
    else if(@showAll = 1 AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND UPPER(TITLE) LIKE '%' + @title + '%' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* City only */
    else if(@showAll = 1 AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND CITY LIKE '%' + @city + '%' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

/* Non-Admin User */
    /* 5C5 */
    /* Start, end, state, title AND city are provided */
    else if(@showAll = 0 AND @start <> '' AND @end <> '' AND @state <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start AND BEGIN_DATE <= @end))
            AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND CITY LIKE '%' + @city + '%' AND STATUS = 'A'
             AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* 5C4 */
    /* Start, end, state AND title are provided */
    else if(@showAll = 0 AND @start <> '' AND @end <> '' AND @state <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start AND BEGIN_DATE <= @end))
            AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND STATUS = 'A'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, end, title AND city are provided */
    else if(@showAll = 0 AND @start <> '' AND @end <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start AND BEGIN_DATE <= @end))
            AND UPPER(TITLE) like '%' + @title + '%' AND CITY LIKE '%' + @city + '%' AND STATUS = 'A'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, end, state AND city are provided */
    else if(@showAll=0 AND @start <> '' AND @end <> '' AND @state <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start AND BEGIN_DATE <= @end))
            AND @state = STATE_PROVINCE AND CITY LIKE '%' + @city + '%' AND STATUS = 'A'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, state, title AND city are provided */
    else if(@showAll = 0 AND @start <> '' AND @state <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >=@start))
            AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND CITY LIKE '%' + @city + '%' AND STATUS = 'A'
             AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End, state, title AND city are provided */
    else if(@showAll = 0 AND @end <> '' AND @state <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE <= @end))
            AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND CITY LIKE '%' + @city + '%' AND STATUS = 'A'
             AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* 5C3 */
    /* Start, end AND state are provided */
    else if(@showAll = 0 AND @start <> '' AND @end <> '' AND @state <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE <= @end AND BEGIN_DATE >= @start ))
            AND @state = STATE_PROVINCE AND STATUS = 'A'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* Start, end AND title are provided */
    else if(@showAll = 0 AND @start <> '' AND @end <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE <= @end AND BEGIN_DATE >= @start ))
             AND UPPER(TITLE) LIKE '%' + @title + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* Start, end AND city are provided */
    else if(@showAll = 0 AND @start <> '' AND @end <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start AND BEGIN_DATE <= @end))
            AND CITY LIKE '%' + @city + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, state AND title are provided */
    else if(@showAll = 0 AND @start <> '' AND @state <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start)
            AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND STATUS = 'A'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, state AND city are provided */
    else if(@showAll = 0 AND @start <> '' AND @state <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start))
            AND @state = STATE_PROVINCE AND CITY LIKE '%' + @city + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start, title AND city are provided */
    else if(@showAll = 0 AND @start <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE >= @start))
            AND UPPER(TITLE) LIKE '%' + @title + '%' AND CITY LIKE '%' + @city + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End, state AND title are provided */
    else if(@showAll = 0 AND @end <> '' AND @state <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE <= @end)
            AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End, state AND city are provided */
    else if(@showAll = 0 AND @end <> '' AND @state <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE <= @end))
            AND @state = STATE_PROVINCE AND CITY LIKE '%' + @city + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End, title AND city are provided */
    else if(@showAll = 0 AND @end <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE <= @end))
            AND UPPER(TITLE) LIKE '%' + @title + '%' AND CITY LIKE '%' + @city + '%' AND STATUS = 'A'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* State, title AND city are provided */
    else if(@showAll = 0 AND @state <> '' AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND CITY LIKE '%' + @city + '%' AND STATUS = 'A'
             AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
/* 5C2 */

    /* Start AND end are provided */
    else if( @showAll = 0 AND @start <> '' AND @end <> '' )
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND ((BEGIN_DATE <= @end AND BEGIN_DATE >= @start ))
        AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start AND state are provided */
    else if(@showAll = 0 AND @start <> '' AND @state <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start  )
            AND @state = STATE_PROVINCE AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start AND title are provided */
    else if(@showAll = 0 AND @start <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start  )
            AND UPPER(TITLE) LIKE '%' + @title + '%' AND STATUS = 'A'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start AND City are provided */
    else if(@showAll = 0 AND @start <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start  )
            AND CITY LIKE '%' + @city + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End AND state are provided */
    else if(@showAll = 0 AND @end <> '' AND @state <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE <= @end)
            AND @state = STATE_PROVINCE AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())

        ORDER BY BEGIN_DATE;

    /* End AND title are provided */
    else if(@showAll = 0 AND @end <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE <= @end) AND STATUS = 'A'
            AND UPPER(TITLE) LIKE '%' + @title + '%'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* End AND city are provided */
    else if(@showAll = 0 AND @end <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE <= @end)
            AND CITY LIKE '%' + @city + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* State AND title are provided */
    else if(@showAll = 0 AND @state <> '' AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND @state = STATE_PROVINCE AND UPPER(TITLE) LIKE '%' + @title + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    
    /* State AND city are provided */
    else if(@showAll = 0 AND @state <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND @state = STATE_PROVINCE AND CITY LIKE '%' + @city + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;    

    /*Title AND city are provided */
    else if(@showAll = 0 AND @title <> '' AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND UPPER(TITLE) LIKE '%' + @title + '%' AND CITY LIKE '%' + @city + '%' AND STATUS = 'A' AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    /* Start only */
    else if(@showAll = 0 AND @start <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (BEGIN_DATE >= @start) AND STATUS = 'A'
             AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    
    /* End only */
    else if(@showAll = 0 AND @end <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND(BEGIN_DATE <= @end ) AND STATUS = 'A'
             AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* State only */
    else if(@showAll = 0 AND @state <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND @state = STATE_PROVINCE AND STATUS = 'A'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

    
    /* Title only */
    else if(@showAll = 0 AND @title <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND UPPER(TITLE) like '%'+@title+'%' AND STATUS='A'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;
    
    /* City only */
    else if(@showAll = 0 AND @city <> '')
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND CITY LIKE '%' + @city + '%' AND STATUS = 'A'  AND (BEGIN_DATE > GETDATE() OR END_DATE >= GETDATE())
        ORDER BY BEGIN_DATE;

GO